﻿
-- -- 取得所有人员信息
CREATE procedure [dbo].[RyInfo_GetAll]
as
select Ry_Info.*,bzmc qybmm from Ry_Info
left join Bzry_Info on(Ry_Info.sfzh=Bzry_Info.sfzh)
left join Banz_Info on (Bzry_Info.bzid=Banz_Info.bzid)